﻿/*
后期部署脚本模板							
--------------------------------------------------------------------------------------
 此文件包含将附加到生成脚本中的 SQL 语句。		
 使用 SQLCMD 语法将文件包含到后期部署脚本中。			
 示例:      :r .\myfile.sql								
 使用 SQLCMD 语法引用后期部署脚本中的变量。		
 示例:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
delete slg_bd_race;
delete slg_bd_avatar;

insert into slg_bd_race ([Id],[Caption],[ResPath],[SortIndex]) values (1,'人类','res/bd/race/1.png',1)
insert into slg_bd_race ([Id],[Caption],[ResPath],[SortIndex]) values (2,'恶魔','res/bd/race/2.png',2)
insert into slg_bd_race ([Id],[Caption],[ResPath],[SortIndex]) values (3,'天使','res/bd/race/3.png',3);

insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(1,'res/bd/avatar/001.png',1);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(2,'res/bd/avatar/002.png',2);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(3,'res/bd/avatar/003.png',3);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(4,'res/bd/avatar/004.png',4);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(5,'res/bd/avatar/005.png',5);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(6,'res/bd/avatar/006.png',6);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(7,'res/bd/avatar/007.png',7);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(8,'res/bd/avatar/008.png',8);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(9,'res/bd/avatar/009.png',9);
insert into slg_bd_avatar ([Id],[ResPath],[SortIndex]) values(10,'res/bd/avatar/010.png',10);

-- insert bd king
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(1,1,1,1);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(2,1,2,2);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(3,1,3,3);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(4,2,4,1);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(5,2,5,2);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(6,2,6,3);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(7,3,7,1);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(8,3,8,2);
insert into slg_bd_king([Id],[Race],[Avatar],[SortIndex]) values(9,3,9,3);
